Skip to main content

Percona Monitoring nodes Setup

Setup mysql nodes for Percona PMM​

Scope​

Used for monitoring mysql database metrics via Percona Monitoring & Management stack

Service ports: 443, 44561, 7777

Deployment Instructions​

Create pmm user​

CREATE USER 'pmm'@'127.0.0.1' IDENTIFIED BY 'PASSWORD';
GRANT SELECT, PROCESS, SUPER, REPLICATION CLIENT, SHOW VIEW ON *.* TO 'pmm'@'127.0.0.1';
GRANT SELECT, UPDATE, DELETE, DROP ON performance_schema.* TO 'pmm'@'127.0.0.1';
FLUSH PRIVILEGES;

Configure db nodes​

percona-release setup pmm3-client
apt update
apt install pmm-client -y

For Production VMs (same vpc as monitoring vm)​

pmm-admin config --server-insecure-tls --server-url=https://admin:PASSWORD@192.168.0.22:8081

pmm-admin add mysql \
  --username=pmm \
  --password="PASSWORD" \
  --host=127.0.0.1 \
  --port=3306 \
  --query-source=slowlog \
  --environment=production \
  MySQL-Primary


  pmm-admin add mysql \
  --username=pmm \
  --password="PASSWORD" \
  --host=127.0.0.1 \
  --port=3306 \
  --query-source=slowlog \
  --environment=production \
  MySQL-Replica

Staging nodes​

pmm-admin config --server-insecure-tls --server-url=https://admin:PASSWORD@percona.seirpk.com

pmm-admin add mysql --username=pmm --password="PASSWORD" --host=127.0.0.1 --port=3306 --query-source=slowlog --environment=staging MySQL-Primary-Stg
pmm-admin add mysql --username=pmm --password="PASSWORD" --host=127.0.0.1 --port=3306 --query-source=slowlog --environment=staging MySQL-Replica-Stg